Sheet Tab settings

%3CLINGO-SUB%20id%3D%22lingo-sub-1337628%22%20slang%3D%22en-US%22%3ESheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337628%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Sir%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20unable%20to%20move%20or%20copy%20or%20delete%20the%20sheet%20by%20using%20right%20click%20of%20the%20Mouse.%20I%20t%20is%20possible%20to%20do%20through%20Keyboard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20provide%20the%20solution%20to%20do%20the%20same%20through%20Right%20click%20of%20the%20Mouse.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1337628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337711%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337711%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636847%22%20target%3D%22_blank%22%3E%40s_p_venugopal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20problem%20from%20your%20mouse%20or%20you%20need%20information%20on%20how%20to%20complete%20the%20task%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20clarify%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337726%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337726%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636847%22%20target%3D%22_blank%22%3E%40s_p_venugopal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20right-click%20on%20the%20tab%20(sheet)%26nbsp%3Bas%20shown%20be%20unless%20your%20mouse%20is%20not%20functional%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wumolad_0-1587832797363.png%22%20style%3D%22width%3A%20283px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186652iDCF94F5575DA9765%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22wumolad_0-1587832797363.png%22%20alt%3D%22wumolad_0-1587832797363.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337736%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337736%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636847%22%20target%3D%22_blank%22%3E%40s_p_venugopal%3C%2FA%3E%26nbsp%3Bif%2C%20however%2C%20the%20right-click%20button%20of%20your%20mouse%20is%20not%20working%2C%20you%20can%20use%20this%20option%20by%20going%20to%20the%20Home%20tab%20and%20choose%20format%20inside%20the%20cell%20group.%20Then%20click%20on%20move%20or%20copy%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wumolad_0-1587833273395.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186653i8F3651846BC9281D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22wumolad_0-1587833273395.png%22%20alt%3D%22wumolad_0-1587833273395.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337748%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337748%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20this%3C%2FP%3E%3CP%3EPress%20Alt%2BF11%3C%2FP%3E%3CP%3Eit'll%20take%20you%26nbsp%3B%20to%20the%20visual%20basic.%3C%2FP%3E%3CP%3ENow%20type%20this%20ctrl%2BG%20it'll%20focus%20you%20to%20immediate%20window.%20Type%20this%20and%20press%20Enter%3C%2FP%3E%3CP%3Eapplication.commandbars(%22Cells%22).reset%3C%2FP%3E%3CP%3E%26nbsp%3BPRESS%20ENTER.%20Try%20after%20that%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636847%22%20target%3D%22_blank%22%3E%40s_p_venugopal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1338238%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1338238%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597404%22%20target%3D%22_blank%22%3E%40gyankosh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20gone%20through%20the%20procedure%20given%20by%20you.%20Getting%20the%20error%2C%20as%20given%20below.%3C%2FP%3E%3CP%3ERun-time%20error%20'5'%3C%2FP%3E%3CP%3EInvalid%20procedure%20call%20or%20argument%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20further.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1338429%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20Tab%20settings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1338429%22%20slang%3D%22en-US%22%3E%3CP%3Ecell%20not%20cells.%20I%20typed%20yesterday%20so%20got%20the%20wrong%20spelling.%3C%2FP%3E%3CP%3Eapplication.CommandBars(%22cell%22).Reset%3C%2FP%3E%3CP%3EIt%20won't%20cause%20the%20error.%3C%2FP%3E%3CP%3ETry%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636847%22%20target%3D%22_blank%22%3E%40s_p_venugopal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

Hi @s_p_venugopal 

 

Is this a problem from your mouse or you need information on how to complete the task?

 

Please clarify

 

Cheers

Highlighted

Hi @s_p_venugopal 

 

You can right-click on the tab (sheet) as shown be unless your mouse is not functional 

 
 

wumolad_0-1587832797363.png

Highlighted

@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.

 

wumolad_0-1587833273395.png

 

Highlighted

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

 

@s_p_venugopal 

Highlighted

@gyankosh 

 

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.

Highlighted

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