I have hidden all command bars in my workbook with
For Each bar In Application.CommandBars
bar.Enabled = False
Next bar
and this properly hides all command bars giving me a lot more real
estate in each worksheet
However, the right-click functionality is completely disabled. Is
there any way to restore this?
I'd like the user to be able to at minimum, be able to edit comments
and clear contents over a range.
Thanks
-Sharat
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
