Results 1 to 2 of 2
  1. #1
    petatt is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    London
    Posts
    1

    Question Hyperlink to password protected excel spreadsheet - password pop-up box hidden behind database

    Very much a beginner here, sorry!



    I have a hyperlink from a form to open a password protected excel spreadsheet. The password pop-up box is hidden behind access, but I can't minimise access as I get the blue-swirly-circle-hourglass-thing.

    If excel is already open I can click on the toolbar to bring excel to the front and enter password.

    If excel is not open I have to ctrl-alt-del, and use task manager to get to the password pop-up box.

    Is there a way to automatically bring the pop-up to the front?

    Many thanks,

    Peter

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you cant via the hyperlink
    instead, try calling excel...

    docmd.minimize 'shrink accesss
    call shell("c:\folder\excel.exe", hyperlinkpath)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-10-2016, 07:14 AM
  2. Password Protected Query Database
    By avicknair in forum Queries
    Replies: 9
    Last Post: 10-29-2015, 02:08 PM
  3. Replies: 3
    Last Post: 12-15-2014, 06:43 PM
  4. Refresh Password protected excel from access
    By ragsgold in forum Programming
    Replies: 3
    Last Post: 01-16-2013, 06:20 PM
  5. Replies: 2
    Last Post: 09-21-2012, 05:12 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums