Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking whether a workbook has been unlocked
I am trying to find an attribute that will allow me to check if the
currently open workbook is protected or if the user has unlocked it. I only want a user to be able to click on a couple buttons if they've unlocked the book. My VBA code locks the workbook as soon as it is opened, but I want people who know the password to be able to unlock the book and use these buttons. I've tried using ThisWorkbook.VBProject.Protection but I get an error saying that Method "VBProject" of object "_Workbook" failed and I haven't been able to find anything else in the google newsgroups. Zach |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking whether a workbook has been unlocked
Define what you mean by locked. Show the code that locks the workbook.
-- Regards, Tom Ogilvy " wrote: I am trying to find an attribute that will allow me to check if the currently open workbook is protected or if the user has unlocked it. I only want a user to be able to click on a couple buttons if they've unlocked the book. My VBA code locks the workbook as soon as it is opened, but I want people who know the password to be able to unlock the book and use these buttons. I've tried using ThisWorkbook.VBProject.Protection but I get an error saying that Method "VBProject" of object "_Workbook" failed and I haven't been able to find anything else in the google newsgroups. Zach |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking whether a workbook has been unlocked
Sure. I have this in the Workbook_Open() Sub.
ThisWorkbook.Protect Password:="password" By locked, I mean password protected. Zach Tom Ogilvy wrote: Define what you mean by locked. Show the code that locks the workbook. -- Regards, Tom Ogilvy " wrote: I am trying to find an attribute that will allow me to check if the currently open workbook is protected or if the user has unlocked it. I only want a user to be able to click on a couple buttons if they've unlocked the book. My VBA code locks the workbook as soon as it is opened, but I want people who know the password to be able to unlock the book and use these buttons. I've tried using ThisWorkbook.VBProject.Protection but I get an error saying that Method "VBProject" of object "_Workbook" failed and I haven't been able to find anything else in the google newsgroups. Zach |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking whether a workbook has been unlocked
If thisworkbook.ProtectStructure or thisworkbook.ProtectWindows then
msgbox "Workbook is protected" end if -- Regards, Tom Ogilvy " wrote: Sure. I have this in the Workbook_Open() Sub. ThisWorkbook.Protect Password:="password" By locked, I mean password protected. Zach Tom Ogilvy wrote: Define what you mean by locked. Show the code that locks the workbook. -- Regards, Tom Ogilvy " wrote: I am trying to find an attribute that will allow me to check if the currently open workbook is protected or if the user has unlocked it. I only want a user to be able to click on a couple buttons if they've unlocked the book. My VBA code locks the workbook as soon as it is opened, but I want people who know the password to be able to unlock the book and use these buttons. I've tried using ThisWorkbook.VBProject.Protection but I get an error saying that Method "VBProject" of object "_Workbook" failed and I haven't been able to find anything else in the google newsgroups. Zach |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking whether a workbook has been unlocked
Awesome. Thank you.
Zach Tom Ogilvy wrote: If thisworkbook.ProtectStructure or thisworkbook.ProtectWindows then msgbox "Workbook is protected" end if -- Regards, Tom Ogilvy " wrote: Sure. I have this in the Workbook_Open() Sub. ThisWorkbook.Protect Password:="password" By locked, I mean password protected. Zach Tom Ogilvy wrote: Define what you mean by locked. Show the code that locks the workbook. -- Regards, Tom Ogilvy " wrote: I am trying to find an attribute that will allow me to check if the currently open workbook is protected or if the user has unlocked it. I only want a user to be able to click on a couple buttons if they've unlocked the book. My VBA code locks the workbook as soon as it is opened, but I want people who know the password to be able to unlock the book and use these buttons. I've tried using ThisWorkbook.VBProject.Protection but I get an error saying that Method "VBProject" of object "_Workbook" failed and I haven't been able to find anything else in the google newsgroups. Zach |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
Checking for open workbook... | Excel Programming | |||
Checking 2 c if workbook exists | Excel Programming | |||
Checking for Open Workbook | Excel Programming |