Hide/unhide button based on data validations

**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