Bypass the save as macro free workbook pop-up
Hello
I was wondering is there a way to bypass the save a macro free workbook pop-up when I try to saveas.
I have two buttons on my template file one of the buttons is assigned to a macro that saves the file by getting info from the file.
Below is the code.
Sub SavingFile()
Application.ScreenUpdating = False
Dim myPath As String
Dim myFile As String
Dim myExt As String
Dim FileFormat As Long
Dim mySerial As String
'
' Set Varibles
'
myPath = "K:\Engineering\Project Planning Sheets\"
myFile = "44OP-" & Range("AB8").Value & "_" & Range("H5").Value & "_" & Range("G8").Value
myExt = ".xlsx": FileFormatNum = 51
mySerial = ""
ActiveWorkbook.SaveAs Filename:=myPath & myFile & mySerial & myExt, _
FileFormat:=FileFormatNum
Application.ScreenUpdating = True
End Sub
As a side note, is there a way to remove the button so the user does not seet them when saving to a macro-free file
Anwsers to the Problem Bypass the save as macro free workbook pop-up
Download Error Fixer for Free Now
Did you try Application.DisplayAlerts=False ?
Cheers
Rich
To check for Windows updates
- Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
- In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
- If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
Another Safe way to Repair the Problem: Bypass the save as macro free workbook pop-up:
How to Fix Bypass the save as macro free workbook pop-up with SmartPCFixer?
1. Download SmartPCFixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. When the Fixing part is done, your computer has been speeded up and the errors have been removed
Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.2.2.0.0 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.2.2.3.0 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.2.0.6.22 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.1.1.88.1 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: BSoD - 2 errors - \"Page Fault in Nonpaged Area\" and \"System Service Exception.\" [Solved],Brightness change when maximising windows on HDTV [Anwsered],How to Fix Problem - bookmark will disappear from links menu after i use that bookmark?,Troubleshooting:C:\\progra~2\\browse~2\\browse~1.dll error Error,How to Resolve - Calculating a value using an expression in an Access Query?,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work
No comments:
Post a Comment