+ Reply to Thread
Results 1 to 5 of 5

Need help with Excel dialog sheets

  1. #1
    Registered User
    Join Date
    05-15-2005
    Posts
    10

    Need help with Excel dialog sheets

    I have to make some changes to an existing Excel VBA application. I was given a password with which I was able to unprotect the worksheets in the application in order to make necessary changes.
    When I open the application, it starts running automatically with a dialog box showing up. My problem is that I need to unlock the dialog box so I could make changes to the controls and assigned macros but I have no idea how to do that since I am quite new to VBA. Can anyone please help me?

  2. #2
    Forum Contributor keithl816's Avatar
    Join Date
    03-18-2005
    Location
    Georgia
    MS-Off Ver
    2000
    Posts
    188
    Hi Alexander,

    Go to Tools/Macros/Visual Basic Editor

    Right Click VBA Project you are on
    Click VBA Project Properties
    Take check out of "Lock project for viewing"
    Enter Password/Confirm

    If you still have problems try disabling the macros first.

  3. #3
    Registered User
    Join Date
    05-15-2005
    Posts
    10
    Hello Keith,

    Thanks a lot but the problem is still there. The project has apperently not been locked for viewing because I have access to all the Excel objects and modules. However, I cannot find the forms or dialog sheets or dialog boxes in the object explorer but when I run the program they show up. Any further suggestions?

  4. #4
    Forum Contributor keithl816's Avatar
    Join Date
    03-18-2005
    Location
    Georgia
    MS-Off Ver
    2000
    Posts
    188
    have you checked for code in 'This Workbook' Right click it and click on view code. See if there is something in there that is causing your problem.

  5. #5
    Registered User
    Join Date
    05-15-2005
    Posts
    10
    Hello Keith,

    Thanks very much for your help. There was actually no code in the Workbook code window but I found that the visible property for some of the sheets were set to veryhidden. I changed this to visible and those sheets showed up. However I do realise that there are yet some dialog sheets that have been referred to in the codes which don't even appear in the Excel objects list in the project explorer. Also in the properties box for the workbook, I find a number of asterics (*****) against the password property and also against the writepassword property which makes me think there is some further protection on some parts of the program. I tried deleting those asterics but they reappear at the click of a mouse. How do I solve this and have access to those hidden dialog sheets. Any suggestion will be very much appreciated.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1