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

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

or, if you have the files on a server, you can use a gpo to disable items. i
disable macros and protection this way for certain users and let managers
see these options so they can run the macros.

--


Gary


"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

Keith wrote:
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

The method posted by Bob works fine for the first part, but the second
part doesn't work. after Controls("Format"). It doesn't like Controls
again.

If this data is really sensitive, then don't put it into your excel file.

Worksheet protection is easily broken.

Keith wrote:

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

--

Dave Peterson

"Keith" wrote in message
...
Keith wrote:

The method posted by Bob works fine for the first part, but the second
part doesn't work. after Controls("Format"). It doesn't like Controls
again.

It worked fine for me Keith ?


Bob