Hide/unhide button based on data validations

**Leith Ross** · 10-08-2009, 09:19 PM

Hello Jazzy Max,

Can you post your workbook? It will be easier to determine what is happening.

**Jazzy Max** · 10-08-2009, 09:27 PM

ok here it is.

I have only uploaded the relevant sheet, is that ok? or you prefer the whole workbook?

Anyway, when the workbook is opened, the following should happen:

-A Msgbox should pop up saying: Please enable macros etc..
-Auto zoom to 80%

BUT what is happening is Cell C3 is selected for no reason at all! it is totally irrelevant.

Thanks Leith I really really appreciate your help. This is due in about 3 hours and this is all that I am stuck on.

**Leith Ross** · 10-08-2009, 09:30 PM

Hello Jazzy Max,

I didn't look at your profile. You are using Excel 2007, which I don't have and neglected to mention. You will have to post a copy in "97-2003" format before I can open it. Even the mods make mistakes.

**Jazzy Max** · 10-08-2009, 09:36 PM

Not a problem at all

I have just saved it in 97-2003 mode. A lot of 'loss of functionality' things came up so I am not sure that you will be able to see what I really want to show.

Here we go..

**Leith Ross** · 10-08-2009, 10:00 PM

Hello Jazzy Max,

Whatever functionality was lost didn't effect the original problem. I rewrote the Workbook_Open() macro and delete two worksheet event routines that duplicated the open event. Here is the macro which has been added to the attached workbook.

Private Sub Workbook_Open()
  Sheet5.Activate
  Sheet5.Range("L11").Select
  
  ActiveWindow.Zoom = 80
  ActiveWindow.ScrollRow = 1
  ActiveWindow.ScrollColumn = 1
  Msgbox "Please enable macros before proceeding"
End Sub

**Jazzy Max** · 10-08-2009, 10:00 PM

Hi Leith,

Its cool now, I played around a bit tried to read and understand what each line means.

I didn't have the code in the 'This Workbook' section.

You have been great, thank you very much for your assistance

reps added