Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show' Read Only' On A Form
Hi,
I have a spreadsheet at work that loads a form at start up. The form covers the whole of the screen, so therefore cannot see the spreadsheet. Is there away to show via a label on the form, if the file as been opened in read or read only? as the user sometime updates the spreadsheet via the form but forgets they are in read only. Please help Dave -- Please remove "no.thanks." and add "blue" in front of yonder to email me. Sorry for inconvenience but feed up of spam mail |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show' Read Only' On A Form
Private Sub Userform_Initialize()
If ThisWorkbook.ReadOnly Then Userform1.Label1.Caption = "Workbook is Read Only" Else Userform1.Label1.Caption = "Workbook is editable" End If End Sub Regards, Tom Ogilvy Dave wrote in message ... Hi, I have a spreadsheet at work that loads a form at start up. The form covers the whole of the screen, so therefore cannot see the spreadsheet. Is there away to show via a label on the form, if the file as been opened in read or read only? as the user sometime updates the spreadsheet via the form but forgets they are in read only. Please help Dave -- Please remove "no.thanks." and add "blue" in front of yonder to email me. Sorry for inconvenience but feed up of spam mail |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having a cell show X but read something else? | Excel Discussion (Misc queries) | |||
OPEN ONLY IN READ ONLY FORM | Excel Discussion (Misc queries) | |||
read-only form | Excel Discussion (Misc queries) | |||
ChristopherTri - Please read reply to Sorting with a Macro or Form | Excel Discussion (Misc queries) | |||
Show cells have been read - linked | Excel Discussion (Misc queries) |