This action won't work on multiple selections.... But no multiple selections selected ?!?

[velohead]

Hi All,



Excel 2016



I have received a spreadsheet containing 10 visible sheets, 14 hidden sheets, and 1 very hidden sheet.

I have unhidden all sheets, and selected cell A1 in all sheets, ensuring those cells are not merged cells.

I save the file, then try to add a new sheet. I am unable to add a new sheet, with the error message as follows.. This action won't work on multiple selections.



OK, how to I debug this ? Anyone had this problem, or know the cause.

I assume no sheets are protected (is there a VBA code to check this ?)

I also assume the workbook is not protected (is there a VBA code to check this ?)

Only single sheets are selected.

Only single cells are selected.



Thank You Hive Mind.

 

[bebo021999]

1- Try to close workbook, then open again.
2- Is there macros on the workbook? if then, try to post here
3- Alt-F11/insert module, run this code:

Option Explicit
Sub test()
Debug.Print Selection.Count
Debug.Print Selection.Address
End Sub

What is printed out in lower immediate window?

 

[velohead]

Thanks for replying, bebo021999.

No macro in the file, as it is a .xlsx

I have converted the file to .xlsx, added the code above, results in the immediate window are....
1
$A$1

I presume that does the first worksheet, and that I have to run for each sheet. Is that correct ?

 

[velohead]

I presume that does the first worksheet, and that I have to run for each sheet. Is that correct ?

I have run the macro in each worksheet, and the count of selection is 1 in every case.


Edit..
And I tried adding a sheet to .xlsm and it works !!!

 

[bebo021999]

how about
debug.print activesheet.name
?
Is it current tab 'sname?

 

[bebo021999]

Could you pos an image/screenshot? try to display tab name.

 

[velohead]

PROBLEM FIXED !!!!

as you say, save file, close, reopen, add sheet - this works.