Unprotected Workbook Issues

[xjohnson]

Hello,

When the workbook is protected these are working properly:

Rename tabs (changing B4:I4 in Vehicle Information sheet changes the tab names)
Putting "X" in column "O" of vehicle sheets by clicking on cells
Clicking the large green shape on vehicle sheets does post the entries to the Service Log sheet and clears those entries from vehicle sheet
Hyperlinks work on the Vehicle Information Sheet

But when Unprotecting Workbook and I select all on any sheet it has error and closes program.

The password is "password" or select the Unprotect or Protect on the Vehicle Information.

If someone has a chance please can you see how to fix this issue and maybe check my codes for efficiency.

Thank you very much for your help and maybe someone can benefit from this version when it's working properly.

[davesexcel]

You probably get an overflow error, you need to error trap in-case too many cells are selected.

Please Login or Register  to view this content.

[xjohnson]

Thank you is there a way to correct it but keep all functions working?

[rorya]

You need to use CountLarge there:

Please Login or Register  to view this content.

and I suggest you amend the SelectionChange code in the sheet to only check the used range:

Please Login or Register  to view this content.

[FoxSeaLady]

Hi

You have to change the Private Sub to coding sugested by Davesexcel #2

to find it click Delveloper in ribbon and select visial Basic.
You will see a window in the left pane Right click This Workbook/View code.
Scroll down until you find :-

Please Login or Register  to view this content.

and make changes. I tested on Service Log tab with no problems.

Cheers

[xjohnson]

Thank you everyone for you help.

I tried the suggestions and the best one without any errors so far is #4 rorya's suggestions.

I really appreciate the help.

Cheers!

[xjohnson]

I did encounter an error on the hyperlinks to sheets:

If Not Intersect(Selection, UsedRange) Is Nothing Then

Please Login or Register  to view this content.

[rorya]

OK, you need to test if the selection is on the same sheet:

Please Login or Register  to view this content.

[xjohnson]

Very good it works thank you so much!

[rorya]

Glad to help. Thanks for the rep.