ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I simulate menus through macro (Visual BasiC) ? (https://www.excelbanter.com/excel-programming/317161-how-can-i-simulate-menus-through-macro-visual-basic.html)

byv770

How can I simulate menus through macro (Visual BasiC) ?
 
Hello,
I am on the point to write a specific macro allowing me to :
.. protect only a range of cells in a shared Excel workbook.

I did the process manually and, now I need to automate it. But, I don't know
how to simulate the "format" and "tools" menu; and their specific options.

THanks for your help,

Alain


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

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