LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 194
Default Stuck myself - can't bring back "VeryHidden"

I coded a Workbook_Open event that included
Worksheets("Sheet1").Visible = xlVeryHidden
Worksheets("TIRs").Visible = xlVeryHidden
leaving Sheet3 visible. I have a Command button on Sheet3 that is supposed
to unhide Sheet1 and make Sheet3 VeryHidden, leaving TIRs VeryHidden. But I
can't make it work!

Some thoughts - but I don't know if they have any significance:
* The Open event is in ThisWorkbook, but the CommandButton1 is in Sheet3
* The code for the button is trying to VeryHide the sheet the button is
on, which includes the code module

I've tried just about every combination of commands from the NG and the help
files, and even had a VB programmer standing here - but it won't go! Can
someone please point me in the right direction?

Ed


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to password-protect "VeryHidden" worksheet exalan New Users to Excel 4 May 9th 09 08:13 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How do I remove a flash object "stuck on" my spreadsheet? SlowLearner Excel Discussion (Misc queries) 1 September 15th 06 11:03 PM
Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? mshellz2u Excel Discussion (Misc queries) 2 June 28th 06 08:08 PM
program stuck at "Save Cancelled by Operator" MainelyPat Excel Discussion (Misc queries) 3 April 20th 06 06:23 PM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"