1. The standard approach is to have a separate sheet that has a message on
it saying that macros need to be enabled. Hide all sheets except this one,
and create a workbook_open piece of code that does your biz and hides this
warning sheet. If they disable macros, all they will see is the warning.

2.You could disable the menu items.

application.CommandBars("Worksheet Menu
Bar").Controls("Format").controls("Row").Controls( "Unhide").enabled=false


--
HTH

Bob Phillips

"Keith" wrote in message
...
Hi,

I have a spreadsheet that, when opened it checks who the user is then
hides specific rows based on the user. Unfortunately I have two problems

1. If they Select Disable Macros then they can see the whole
spreadsheet. How can I make it so that if they disable then the
spreadsheet just closes?

2. Once the routine has run and the rows are all hidden how do I stop
users just dragging the rows back out, or selecting an group then
selecting unhide?

Any help would be greatly appreciated.

Thanks

Keith