VBA Code to stop users Saving

Hi

I have a simple spreadsheet and want to prevent people saving the spreadsheet if they havent completed certain cells. and if possible have the cursor take them to the cells they havent completed. (though that part not quite so vital)

Can anyone help?

Im a reasonable excel user but not good at VBA / Macros.

Thanks

D

Hi

Thanks for the help but when I try and save I get the error message

'Compile error: variable not defined'

and it highlights the word 'cell' on the line of code

'For Each cell In CheckRNG'

Any ideas?
D

Think thats done it! - Thank you both!

Ive just thought of another issue! (sorry)

I want to share this spreadsheet with other peopel on a shared drive location.

When they open the form they will save it to their own PC's, complete the form and then email back to me. In effect my form is the template they need to complete a timesheet.

In this scenario how do I ensure the form is saved with all fields blank in the shared location (for users to open and access), but after they have opened it up the Code I have just written initiates so that they must complete certain fields before saving? (they would then email me the completed form)

In effect at the moment for me to save this spreadsheet to a certain location will mean I need to populate fields beforehand?

Am i making sense and is it possible to save the spreadsheet with blank fields and only when they start filling it out themselves does the code initiate?

Possibly this code

Please Login or Register  to view this content.

It's just a bit added to Jerrys' code

Hope this helps

Hmmm...

Saving to a local drive using Design Mode means an unscrupulous user could part fill a form then post from there, mind you if there is a lot to fill in, and perhaps the user needs to wait for information, how else could they save and return later? In my experiance users would prefer to have that option.

The save if all blank option still stands either way.

Cheers