Macro works for me but not user group

M

MLD

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
 
G

Guest

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
 

Ask a Question

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.

Ask a Question

Similar Threads

Macro runs fine from VBEditor, but not button 22
Excel macro works with keyboard shortcut, but not command button. Please Help. 3
SAME MACRO DON’T WORK ON (ActiveX Control) BUTTON BUT WORKS ON (From Control) BUTTON 3
Premium Solver Macro Problem 3
Run existing macro (in module1) from new button (on a worksheet) 4
Works as Macro but not in code 4
Runs in macro but not in procedure...why? 1
Hiding a macro button 2

Top