View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default make button invisible if macros disabled

I have a worksheet with a button on it. Clicking on the button displays a
series of userforms. I have a Workbook_BeforePrint sub that makes the
button's visible property false, so it doesn't print.

I want the button to be invisible if a user opens the file without macros. I
have tried:
1) making the button invisible, and then using the workbook_open sub to
make it visible if macros are enabled. It was still visible without macros
2) Using a cell on the worksheet as a sort of button, and used colors and
borders to make it only appear if macros are enabled. This worked, but it was
really ugly.
3) I considered using Chip Pearson's method for ensuring macros are enabled
(by setting the visibility properties of each sheet:
http://www.cpearson.com/excel/EnableMacros.aspx). However, many of the
features of the workbook are still valuable to the user without macros, and I
want them to be able to use them.

Any thoughts?
Thanks,
~ Horatio