Forum Discussion
Sheet Tab settings
Dear Sir,
I am unable to move or copy or delete the sheet by using right click of the Mouse. I t is possible to do through Keyboard.
Please provide the solution to do the same through Right click of the Mouse.
6 Replies
Try this
Press Alt+F11
it'll take you to the visual basic.
Now type this ctrl+G it'll focus you to immediate window. Type this and press Enter
application.commandbars("Cells").reset
PRESS ENTER. Try after that
I have gone through the procedure given by you. Getting the error, as given below.
Run-time error '5'
Invalid procedure call or argument
Please advise further.
cell not cells. I typed yesterday so got the wrong spelling.
application.CommandBars("cell").Reset
It won't cause the error.
Try this
s_p_venugopal if, however, the right-click button of your mouse is not working, you can use this option by going to the Home tab and choose format inside the cell group. Then click on move or copy sheet.
You can right-click on the tab (sheet) as shown be unless your mouse is not functional
Is this a problem from your mouse or you need information on how to complete the task?
Please clarify
Cheers
