-
Solved: Share a workbook without a prompt
Guys,
I need your help once again, I have written some code to share a workbook, but my code asks for a prompt each time.
How can I modify the code so that it will simply overwrite the saved workbook with the shared workbook without prompting the user.
[VBA]With ActiveWorkbook
.KeepChangeHistory = True
.ChangeHistoryDuration = 30
End With
ActiveWorkbook.SaveAs Filename:= _
"I:\H925 Buying\BuyingTeamsALL\New Essentials Availability Report\2008-2009\07) July 2008\Essentials Availability Report 3007.xls" _
, AccessMode:=xlShared[/VBA]
Thanks in advance for your swift response.
-
[VBA]Application.DisplayAlerts = False
'Your code here.
Application.DisplayAlerts = True[/VBA]
Cordially,
Aaron
Keep Our Board Clean! - Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules