I have a spreadsheet for a T&E Report for my firm. It is two tabs/sheets.
On sheet 1, I added a control button which runs a macro to print both pages
using the sheet setups I already defined. Works great for me. When a user
(an atty or secretary) opens it, the button reverts to Edit Design mode and
will not run.

We are a Novell house with Win XP/Office 2003 clients. We also use Imanage
v.8 (MailSite) for document management.
I have both sheets protected so users can only enter data in the proper
cells and I remembered to UNLOCK the button object's protection property.

Is this more related to network security than a real excel programming
issue?
Any insight would be a huge help.

-Monica

Sounds like a macro security issue to me. Change their setting for macro
security to medium (probably high at the moment). They will then be prompted
to enable macros when they open the spreadsheet.

Tools - Macros - Security
--
HTH...

Jim Thomlinson


"MLD" wrote:

I have a spreadsheet for a T&E Report for my firm. It is two tabs/sheets.
On sheet 1, I added a control button which runs a macro to print both pages
using the sheet setups I already defined. Works great for me. When a user
(an atty or secretary) opens it, the button reverts to Edit Design mode and
will not run.

We are a Novell house with Win XP/Office 2003 clients. We also use Imanage
v.8 (MailSite) for document management.
I have both sheets protected so users can only enter data in the proper
cells and I remembered to UNLOCK the button object's protection property.

Is this more related to network security than a real excel programming
issue?
Any insight would be a huge help.

-Monica