Trashcan Sin
04-17-2011, 08:32 AM
Hello everyone,
This is my first post and I'm probably going to come off as a noob, but I've kind of painted myself into a corner... Any advice would be greatly appreciated.
Last night I was playing around with the application object trying to modify the screen. I must have inadvertently disabled the right clicking functionality. After searching Google for a minute I found you can use the following to get it back when you right click a range.
Application.CommandBars("Cells").Enabled = True
But I still am not able to right click a form or activecontrol button to get a shortcut menu. It just allows me to move it or copy it. I probably should have realized what level I'm at and not gotten into this at all, but...yeah I did...Lesson learned!
Thanks!
Aaron
This is my first post and I'm probably going to come off as a noob, but I've kind of painted myself into a corner... Any advice would be greatly appreciated.
Last night I was playing around with the application object trying to modify the screen. I must have inadvertently disabled the right clicking functionality. After searching Google for a minute I found you can use the following to get it back when you right click a range.
Application.CommandBars("Cells").Enabled = True
But I still am not able to right click a form or activecontrol button to get a shortcut menu. It just allows me to move it or copy it. I probably should have realized what level I'm at and not gotten into this at all, but...yeah I did...Lesson learned!
Thanks!
Aaron