ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   reset me (https://www.excelbanter.com/excel-programming/333933-reset-me.html)

cacique[_5_]

reset me
 

What’s the correct format to use the Reset me command?

I am trying to use but I am getting error "wrong number of arguments or
invalid property assignment"


--
cacique
------------------------------------------------------------------------
cacique's Profile: http://www.excelforum.com/member.php...o&userid=24861
View this thread: http://www.excelforum.com/showthread...hreadid=385456


Tom Ogilvy

reset me
 
Set myBar = CommandBars("Custom")
If user = "Level 1" Then
myBar.Visible = True
Else
.CommandBars("Visual Basic").Reset
myBar.Enabled = False
End If

example from help.

--
Regards,
Tom Ogilvy

"cacique" wrote in
message ...

What's the correct format to use the Reset me command?

I am trying to use but I am getting error "wrong number of arguments or
invalid property assignment"


--
cacique
------------------------------------------------------------------------
cacique's Profile:

http://www.excelforum.com/member.php...o&userid=24861
View this thread: http://www.excelforum.com/showthread...hreadid=385456





All times are GMT +1. The time now is 09:05 PM.

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