Excel always starts in Editing mode; i.e. buttons can be edited etc.

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

Hi,

I have an Excel sheet with lots of VBA in the back and several buttons
on the sheet. If I open this sheet on my own pc it opens in 'run' mode
which means I can click the buttons and everything runs.

When I open it on some other machine it always opens in 'edit' mode
which means I can not click the buttons but only change size etc.
I know I can go to 'run' mode using the control toolbox. But how can I
configure Excel on that machine that it always opens in 'run' mode
automatically??! Thanx!!!
 
Hi

Check the security level on Excel. If you go to tools, macro, security. The security level must be medium

Thank
Marnus
 
You must log in or register to reply here.

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

migrate xls app 2003 to 2007 -- get custom macro button out of des 3
VSTO BeforeDoubleClick edit mode 6
Command Buttons not responding 7
Excel 2007 ribbon issue when in cell edit mode 3
Can't get into design mode in Excel 2007 3
Command Buttons not responding 3
Edit text in a Command button 8
Excel 2007 Design Mode 3

Back
Top