Conflict bewteen EXCEL Macros and Passwords

M

mk

Using Excel 2003 we have developed a spreadsheet comprising a number of
worksheets linked by formulas and a few macros to produce a fancy
report. The macros are for copying sheets (into a new file), pasting
sheets (back into the motherfile), printing sheets and refreshing data.


Our Problem is that once a password is added (to protect sheets and/or
the workbook) the macros won't function without the password being
entered and this defeats the purpose of password protection! This may
be due to conflict betwen the 'unprotect' and 'protect' activities
already in the macros, and the added password.

Perhaps there is another way of protecting these spreadsheets or
solving our problem. Any advise would be appreciated.
MK
 
B

Bob I

Please explain again, why you want to password protect a workbook but
don't want it to be password protected?
 
M

mk

The spreadsheet has been designed for use by others BUT we want to
limit their access to the input of data into unlocked cells only. To do
this we can password protect the workbook BUT then the macros won't
work. If we provide the password to get the macros to work then the
users can use the same passwords to undo the protection and gain 100%
access.
In other words there is no point in using a password. I hope this
explains it better!
 
B

Bob I

Correct. You can't password protect a workbook and expect it to allow
non password protected access, as that would negate the whole point of
password protecting it in the first place.
 
M

mk

OK thanks.
So maybe the solution is not to pasword protect the workbook but to
protect the macros instead - so that while users can make full use of
the workbook they cannot view or edit the macros. That would solve our
problem as long as the protection of the macros does not:
a) conflict with the protect / unprotect commands embedded in the
existing macros, b) require any sort of password to open the workbook
or operate it or run any macros within it, and c) only require a
pasword for the purposes of viewing / editing the macros.

Any chance this sort of thing can be done - simply and without the
conflicts?
 
B

Bob I

Hardly a simple request, or solution. I'd say you are looking at a bit
of programing using visual basic or some thing along those lines in a
add-on that is completely seperate from the spreadsheets in question.
There are some 3rd party "add-ons" for Excel that provide additional
services/formulas specific to various industries.
 
M

mk

Thanks for your input.
Bob said:
Hardly a simple request, or solution. I'd say you are looking at a bit
of programing using visual basic or some thing along those lines in a
add-on that is completely seperate from the spreadsheets in question.
There are some 3rd party "add-ons" for Excel that provide additional
services/formulas specific to various industries.
Click to expand...
 
Top