I have created a PowerPoint Presentation with Excel and I want to save the PPT with a password that is found in a cell in my Excel file.
Here is my code that uses data in my Excel Spreadsheet to name the PPT file:
The password is located in cell P23
Please Login or Register to view this content.
Last edited by Bobbbo; 01-27-2017 at 05:37 PM. Reason: Mark it solved
There are two different passwords a PP Presentation can have:
- User needs password to open and view the file.
- User can open and view the file but needs password to edit the file.
Chose one or both.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrog, I need the one to keep from opening the file. Just to make sure the code would look like this:Originally Posted by AlphaFrog
There are two different passwords a PP Presentation can have:
- User needs password to open and view the file.
- User can open and view the file but needs password to edit the file.
Chose one or both.
Please Login or Register to view this content.
Correct?Please Login or Register to view this content.
AlphaFrog, I tried it out and it worked great. Thank you so much for your great help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks