Hide picture by default, display if macros enabled

**PhearoX** · 04-07-2008, 02:10 PM

Hi all,

Basically, I want cell A1 to display the message "Macros must be enabled for this document to display properly", then have that text replaced with a picture (jpeg logo) if macros are enabled. I know I need to put the code in the Workbook_Open sub, but I keep getting the "error 1004, cannot modify visible property of picture object" when I try to tinker with "visible = true".

*EDIT* - The picture must be embedded in the spreadsheet somehow, and hidden from view when macros are disabled. (Having the picture crammed into a single cell at IV65536 is fine.)

Thoughts?

Thanks!

-PhearoX

**westonkw** · 04-07-2008, 02:34 PM

Sorry I cant help you out on this one, but it sounds like a great feature. I have a workbook that is used by several users, not all of them are familar with excel. I would like to see the code that you are using so far and adapt it so if macros are disabled a massage would show on the front page telling them step by step instructions on how to enable macros. Then after the macros are enabled so the workbook would perform properly this message would be hidden.
Thanks for the idea

**royUK** · 04-07-2008, 02:58 PM

is this what you mean?

**DCSwearingen** · 04-07-2008, 04:01 PM

Originally Posted by royUK

is this what you mean?

The same code works for pictures, inserted in the sheet. When you click on the picture you should see then name Excel gives, in the name box to the left of the formula bar. Just substitute that name for the text box you want visible if macros have been enabled.

You can also hide you primary sheet on closing via VBA, and unhide and activate in with the opening VBA.

**PhearoX** · 04-08-2008, 09:40 AM

Thanks for the advice, but I can't seem to get it to work... That excel sheet does exactly what I need, but I can't get it adapted for whatever reason.

Here's my code:

Please Login or Register  to view this content.

Both Cell "A1" and the picture "Picture 1" are always visible, whether or not macros are enabled. I tried many different ways around this code, used Range instead of Cells, used ActiveSheet instead of Sheet1, tried specifying Picture(1) and Picture("Picture 1"), none of which work.

Any other thoughts?

Thanks!

**PhearoX** · 04-08-2008, 11:06 AM

This is very strange... Even the code below doesn't do anything...

Please Login or Register  to view this content.

Am I missing something here?

**royUK** · 04-08-2008, 11:20 AM

Please Login or Register  to view this content.

This code works fine

Please Login or Register  to view this content.

Are you putting the code in the correct modules?

**PhearoX** · 04-08-2008, 11:31 AM

Hah! Sure enough, I was putting the code in Sheet1 instead of ThisWorkbook.

Thanks again for the help!

**westonkw** · 05-19-2008, 03:07 PM

Is there anyway to get this to come up in a message box instead of a range?

Please Login or Register  to view this content.

**LiamPotter** · 05-20-2008, 05:47 AM

Please Login or Register  to view this content.

Hope that helps - not too sure it will but you asked for MsgBox's!

~Liam

**royUK** · 05-20-2008, 08:38 AM

If macros aren't enabled then the message box will not display on opening, therefore the user may not be aware of the need to enable macros. That's why this type of code requires a visual message - a sheet or image, to make the user aware that macros need enabling.

Hide picture by default, display if macros enabled

LinkBack

Thread Tools

Rate This Thread

Display

Hide picture by default, display if macros enabled

The same thing will work for pictures, just...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions