Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Thelma Murray   on Aug 21 In MS Office Category.

  
Question Answered By: Robin Bailey   on Aug 21

Through experimentaion and other sources, I have made my
userform quiz work exactly how I wanted  it to work thru the code.
As soon as I fix one bug, I will post my spreadsheet  on here and see
how people like it.

Unfortunatly, The Worksheets("sheet1").visible = false (etc.) does
not work for my excel, It keeps giving me the error: Cannot set all
sheets hidden, or something similar.

Is there any other code  anyone can think of to either minimize or
hide the speadsheet while the userform  is active?

I've also tried activeworkbook.worksheets("sheet1").visible =
xlveryhidden, and that does not work either.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on UserForms Or get search suggestion and latest updates.


Tagged: