Home > Software engineering >  EXCEL locking tool bar method
EXCEL locking tool bar method

Time:09-20

Customers have a abnormal condition requirements:
Requires EXCEL toolbar, only file - save, save as function available
Additional EXCEL has designated cell can entry
Thanks for a great god

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

Upstairs nonsense, don't ignore him,

You need to go through after 2007 ribbon is solved

CodePudding user response:

Zhao four post machine often nonsense, it is a word can water years,


Remember to Office on 2000/2003, can be CommandBars set to operation, the specified menu is disabled (gray),
The 2007 (probably higher) really didn't find operation method,

CodePudding user response:

After 2007 operated through "functional areas"
This didn't do too deep research, give a MSDN for reference link
https://msdn.microsoft.com/zh-cn/library/aa942866 (v=versus 80). Aspx
  •  Tags:  
  • VBA
  • Related