ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro (https://www.excelbanter.com/excel-programming/432197-macro.html)

Bogi

Macro
 
My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice

Sam Wilson

Macro
 
That could be because you have security set to disable macros - go to
tools/macros/security and make sure it's set tio "medium" then re-open the
woorkbook.

Sam

"Bogi" wrote:

My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice


Bogi

Macro
 
Thanks, where do I find "tools"
Bogi

"Sam Wilson" wrote:

That could be because you have security set to disable macros - go to
tools/macros/security and make sure it's set tio "medium" then re-open the
woorkbook.

Sam

"Bogi" wrote:

My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice


Bogi

Macro
 
I´m working with Excel 2007, where can I change the security settings

"Sam Wilson" wrote:

That could be because you have security set to disable macros - go to
tools/macros/security and make sure it's set tio "medium" then re-open the
woorkbook.

Sam

"Bogi" wrote:

My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice


Sam Wilson

Macro
 

It's in the trust center settings - I don't use 2007 on this computer so I'm
guessing here, but:

Click on the top-right excel/files icon, and go to Excel options, in there
go to trust centre, settings, and find Macros.

Sam

"Bogi" wrote:

I´m working with Excel 2007, where can I change the security settings

"Sam Wilson" wrote:

That could be because you have security set to disable macros - go to
tools/macros/security and make sure it's set tio "medium" then re-open the
woorkbook.

Sam

"Bogi" wrote:

My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice


Bogi

Macro
 
The macros are enable and the macros doesn't work
Thanks sor your help

"Sam Wilson" wrote:

That could be because you have security set to disable macros - go to
tools/macros/security and make sure it's set tio "medium" then re-open the
woorkbook.

Sam

"Bogi" wrote:

My macro button and visual basic button doesn´t work, either do design mode.
Nothing happens by preesing. They are not highlighted like they used to be.
Please advice



All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com