I am trying to produce a form inexcel whereby users have to complete certain
cells before they are allowed to save the spreadsheet
I am trying to produce a form inexcel whereby users have to complete certain
cells before they are allowed to save the spreadsheet
You could write a macro to intercept the save event, and use the code here to validate the spreadsheet.
For example:
As this will apply to all open workbooks you may want to put in a selection to filter out saves of workbooks you are not intereste in. For example:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Art
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks