Remind the user they're using a read only file.

[wkdintent]

Morning all

My company have a data register in Excel which when opened, gives the user the option of opening a read only version instead of the main file. This is useful as those who just want to check an entry can do, without blocking others from adding to the register.

The issue I have is that some sleepier colleagues forget that they are using the read-only version, and begin trying to add entries.

Is there a way for something to appear on the 'add entry' tab to remind them they're using the read only file? Ideally, it would be something like conditional formatting, causing hidden white text to become red. Plan B would be something along the lines of a macro which, when the user goes to the 'add entry' tab, a they get a message box.

Cheers all.

 

[steve the fish]

Go to the tab in question. Right click. View code. Paste the below in the 'white space'.

Private Sub Worksheet_Change(ByVal Target As Range)

If ActiveWorkbook.ReadOnly Then MsgBox "Read Only!"

End Sub

Your file is then going to need to be an xlsm rather than the xlsx it probably is at the moment. This will work provided your users enable macros on opening the workbook.

 

[wkdintent]

Ah you beauty. I didn't think it would be that simple. It's already .xlsm as it's other functions run macros all over the place.

Cheers.