Limiting the number of times a spreadsheet can be opened

[samxx091]

Hi

Is there any way to build a Macro that limits the number of times a user can access a spreadsheet.

I have spreadsheet that is used by various managers around the organisation, each manager has to select their team and complete the spreadsheet for that month. At the minute they can submit this spreadsheet as many time as they like, i would like to be able to limit them to 1 per month.

I am unsure if this is physically possible but any information would be greatly appreciated.

Kind Regards

Sam

[:) Sixthsense :)]

Yes you can limit the Opening.

Keep a hidden sheet to store open count by placing a code in On open event store the name of the user, Month and increment the opening count in the next cell.

Keep a code in the same open event to check whether the user has already opened the file in that month if so keep a exit code by using an if condition

But the user should enable the macro so that all these can be done, otherwise it's not possible.