Hi!
I am really new to macro and I need to have the first macro merge in to 2nd macro (I need to disable the SAVE/SAVE AS option for integrity of the workbook)
Please Login or Register to view this content.
Please Login or Register to view this content.
I hope someone kind enough to help me on this ☺
Thank you
Do you need to merge macros?
You could save the file that is sent to the users as a "Read Only" with modification rights password protected
This prevents the user from saving any modifications to the file
ReadOnly.jpg
Last edited by Kevin#; 05-21-2016 at 09:00 AM.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
until now, i am using this method but problem is they use the save as to saving it in local and then the file doesnt updateOriginally Posted by Kevin#
1. Which file does not update?
2. Why does it not update?
3. Where is local? On their C: drive?
1. its a xlsx file. this file returns data from a external excel file which is in LAN server
2. external file path doesnt match (maybe a absolute/relative path conflict)
3. local mean any of the 13 area's users local machine
i need to put both the file in LAN server to make it work. its also matter of security
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks