ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CmdBarMenu.Control Deleted (https://www.excelbanter.com/excel-programming/342155-cmdbarmenu-control-deleted.html)

paynep

CmdBarMenu.Control Deleted
 

Hi,
I was experimenting with some VBA code, I have deleted my Save As...
command from the file menu. I have the code to put this back, but I
don't know the syntax to us for the .OnAction line plus it is adde to
the bottom of the file menu. can anyone help?

Thanks


--
paynep
------------------------------------------------------------------------
paynep's Profile: http://www.excelforum.com/member.php...o&userid=27907
View this thread: http://www.excelforum.com/showthread...hreadid=474045


Norman Jones

CmdBarMenu.Control Deleted
 
Hi Paynep,

In Excel:

View | Toolbars | Customize | Commands Tab
Select 'File' in the Categories box
Drag the 'SaveAs...' command and drop it onto the File menu.

---
Regards,
Norman



"paynep" wrote in
message ...

Hi,
I was experimenting with some VBA code, I have deleted my Save As...
command from the file menu. I have the code to put this back, but I
don't know the syntax to us for the .OnAction line plus it is adde to
the bottom of the file menu. can anyone help?

Thanks


--
paynep
------------------------------------------------------------------------
paynep's Profile:
http://www.excelforum.com/member.php...o&userid=27907
View this thread: http://www.excelforum.com/showthread...hreadid=474045




paynep[_2_]

CmdBarMenu.Control Deleted
 

Thanks Norman, worked a treat :)


--
paynep
------------------------------------------------------------------------
paynep's Profile: http://www.excelforum.com/member.php...o&userid=27907
View this thread: http://www.excelforum.com/showthread...hreadid=474045



All times are GMT +1. The time now is 09:41 AM.

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