Run-Time error '1004': when running my code

[galvinpaddy]

Evening Happy campers,

I have 7 spreadsheets (identical apart from saved name) that have 2 command buttons in each, 1st to save the data that has been entered, 2nd to clear all data from specific cells to allow a fresh start.
My issue is with the first code.
*THIS code works fine, no issue, does what i wanted it to.*

Please Login or Register  to view this content.

*THIS code does not work*

Please Login or Register  to view this content.

When i run the code that activates sheetsK7 it brings up a runtime error - *Run-time error '1004': Select method of range class failed* when i click debug, it highlights the following line In yellow as the issue.

Please Login or Register  to view this content.

This is the case for all other sheets, they are named as K1, K2, K3, K4, K5, K6 & K7, yet only K6 appears to work??

Could someone please explain what i am doing wrong here?
Many thanks in advance.
galvinpaddy

[Leith Ross]

Hello galvinpaddy,

Is that sheet protected?

[galvinpaddy]

Hi,
Master Sheet.xls is not protected, however, all the other sheets are. would that cause an issue?

many thanks

[Leith Ross]

Hello galvinpaddy ,

It can if the cell is locked and the sheet protection does not allow the user to select locked cells. I would have the the macro first remove the worksheet's protection, execute, and the reapply the protection. This will require the password to be in the macro. To prevent others from seeing it, you can always password protect your VBA project.

[galvinpaddy]

hhhmmm, the password protection is only active on the sheets K1 - K7 but the cells that are copied in the macro have protection removed to allow copying while locked, the master sheet has no protection on.
Initially i thought that having 7 sheets with similar names would cause it, so changed all names to 1st line, 2nd line etc. but to no avail