Easiest way is to open the workbook then start a macro recording. Unprotect
the sheet and save or save as. stop recording the macro. Then do to the
Visual basic editor where you'll find the code that does it. with minor mods
you can implant it into your Access code.
if you have any further q's email me at: mr dot smith at trearc dot com
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
