Hi,

I set up a timesheet work book for a friend's business. There is a macro that puts all 26 payweeks of the year onto a new sheet as a new year roll over. this macro is on the sheet "set up"

the normal sheet which the day to day users are meant to put their times in is a seperate sheet, which has a print macro in the form of a button for each pay.

The problem is that we dont want the everyday employees using the setup sheet as this has the newyear macro and other inportant links to the work book in it.

We have protected this sheet and locked, hidden and everything that you can think of so the users cant do anything in the "setup".

But guess what....

They can still view the sheet and click the new year button which allows them to roll over the new year. even though the sheet is protected they can run the macro from the button anyway!

I cant diable macro's because then they cant use the print macro on their pay days.

how can i protect the setup sheet so that they cant view it without a password.

or is their another way to tackle this problem, keep in mind that i want the button for the new year still to exist so that the payroll officer can still use it.

Thanks

Hi

The solution is present in the problem statement.itself

Just do a check in your macro with the same business logic you had specified. You can get the logged in user using Win API methods and check for dates as well

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)