Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Powerpoint & Excel security problem

  • 11-04-2005 05:46PM
    #1
    mozilla
    Registered Users, Registered Users 2 Posts: 34 ✭


    hey i gotta do this project for work and am nearly finished but could really do with some advise.

    I've created an Excel spreadsheet with a number of worsheets and charts most of which are linked to a powerpoint presentation using hyperlinks and embedded objects etc to be displayed globally. There are loads of links to be updated, normally this wouldn't pose a problem but the boss wants it that only he and a couple of others can update the data using a password while everyone can read it i.e. only a few can access the excel spreadsheet.

    To do this i went into Excel tools and general options and set a password to modify the data, this works but when i go to update the data in the powerpoint presentation every link requires that this password be entered and will try to do so at the same time causing a deadlock is there any way to get around this problem

    i was thinking a small basic program embedded in the presentation like a button to update all links, when pressed it asks for a password (something similar to a JOptionPane.getInputDialog or the likes) and if the password is correct it activates the hyperlink between the presentation and the spreadsheet, this would mean that i dont need to put a password on the excel sheet as only certain people can access it to change it.
    how can i do this? Java, vb or some fiddeley microsoft awkward crap solutions all welcome.

    this would be a life saver as im gonna crack if i don't figure this out damn microsoft


Advertisement