Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAM CAM is offline
external usenet poster
 
Posts: 65
Default Hide worksheet tab

I have command buttons that will go to one worksheet to another not a
problem, but if I hide the worksheet, which is password protected also I
get an error message. I want to hide the worksheet all but one and use my
command button and have the worksheet password protected "How can I do
this?" Thank you in advance.

Cheers

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,071
Default Hide worksheet tab

CAM
Be specific. You're the only one who knows what you are talking about.
For instance, what sheet contains the buttons? What sheet(s) are hidden?
What sheet(s) are password protected? What macro(s) are executed when you
click on what button? What do want to happen (be specific) when you click
on what button? What is the error message? Include the macro code in your
post and specify the offending line of code when an error occurs. HTH Otto
"CAM" wrote in message
...
I have command buttons that will go to one worksheet to another not a
problem, but if I hide the worksheet, which is password protected also I
get an error message. I want to hide the worksheet all but one and use my
command button and have the worksheet password protected "How can I do
this?" Thank you in advance.

Cheers



Reply
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
Hide a worksheet mac Excel Worksheet Functions 2 September 10th 09 03:00 AM
Hide worksheet kuansheng Excel Worksheet Functions 2 February 14th 06 09:36 AM
VBA to show or hide columns in one worksheet conditioned on value in other worksheet punsterr Excel Programming 1 August 18th 05 09:26 AM
hide worksheet Ankur Excel Discussion (Misc queries) 2 August 11th 05 11:52 AM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM


All times are GMT +1. The time now is 10:37 PM.

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

About Us

"It's about Microsoft Excel"