Enabling Macro But Hiding Sheets

[PRINCE21]

I have created a simple macro that basically when a button is clicked i
takes you to a certain page in the workbook.

Is it possible to hide this page for different users. But when a use
with the correct password comes he can click the button and he will b
taken to the hidden page.

Is it posible to do something like this along those line

 

[JE McGimpsey]

It's possible, and if you search the archives:

http://google.com/advanced_group_search?q=group:*excel*

you'll find many ways to do this.

You should know, however, that none of the methods will prevent anyone
with a functioning neuron or two and the desire to see your hidden sheet
from bypassing your password. The methods are frequently posted on these
newsgroups and on some web sites, including mine:

http://www.mcgimpsey.com/excel/removepwords.html