antman2988
Board Regular
- Joined
- Jun 28, 2018
- Messages
- 78
Hello,
I've been researching for a while now on how to allow the user to select General Option from the Tools drop-down menu during the FileDialog window. This is the current code I have, but is it even possible to enable this option?
Basically, I need to allow the user to enter a password in the Password to Modify field. Is there another way to do this if I already have a predetermined password? I tried changing the file access, but it didn't work correctly.
Thanks!
I've been researching for a while now on how to allow the user to select General Option from the Tools drop-down menu during the FileDialog window. This is the current code I have, but is it even possible to enable this option?
VBA Code:
With oFD2
'strUser = Environ("USERNAME")
.ButtonName = "Save"
.initialFileName = "[Excluded]" _
& saveDate & " PE's LD.xlsb"
.FilterIndex = 3
.Title = "Please choose the folder for the appropriate fiscal year and period."
If .Show = 0 Then Exit Sub 'user cancelled
.Execute 'save active workbook
'path2 = .SelectedItems(1)
'Call ReadOnly(path2)
'.ChangeFileAccess Mode:=xlReadWrite, WritePassword:="TCBPU"
End With
Basically, I need to allow the user to enter a password in the Password to Modify field. Is there another way to do this if I already have a predetermined password? I tried changing the file access, but it didn't work correctly.
Thanks!