LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 576
Default Turn Button On

Tim,

If macros are disabled - the workbook will open in Design Mode.
In Excel 2k and up the security level is automatically set to high at the
time of installation and workbooks with macros will open with macros
disabled.

Your people must have their machines reset to Medium and than they need
to enable macros when opening the workbook...

--
sb
"Tim" wrote in message
...
I have a button on the main sheet programmed to unhide a
second sheet (this is my help file). The button and macro
work fine if the Design Mode is turned off.
Unfortunately, most of the computers at my buisness have
the design mode already turned on, so the button does not
work. Is there a way around this?

Also, I know this is a cheap and dirty way of creating a
help file, but can I create a normal help file for only
this file? I have Excel 2000 with only with VB 6.0.



 
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
How can i turn off the auto fill options button? u01aah Excel Discussion (Misc queries) 1 September 3rd 07 10:41 AM
How can I turn back on the sort button in excel 2007? Jose Liriano Excel Discussion (Misc queries) 2 August 23rd 07 05:10 PM
How do I turn off the autofill option button that comes on? lar.ridge Excel Discussion (Misc queries) 3 September 7th 06 05:53 PM
Cells turn 'hot' and execute distant macro button Kevryl Excel Discussion (Misc queries) 1 March 31st 06 02:08 PM
I can't turn off excel programs with the exit button. What is up. tom moore Excel Discussion (Misc queries) 1 January 15th 05 12:12 AM


All times are GMT +1. The time now is 12:47 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"