Our network uses T1 and the server is in my office.
Saving to the server is normally not slow.
I did check the manual option and unchecked "Recalculate before save" and noticed no difference in the amount of time it took to save.
I will try your suggestions for shortening the code...
You all seem to be in agreement that the code is not the culprit for slowing down the saving process. But my workbook without the code is 200KB and with the code it is 560KB.
When I save it manually (File – Save) without the code it is very quick.
When I save it manually (File – Save) with the...
My problem deals with an Excel Workbook that takes almost 15 seconds to save. Probably because the code and forms it contains makes the size of the file over 500KB. The code calls for the workbook to be saved 3 different times and a new workbook created which also is saved. So it takes almost 1...
Sounded like a good idea, but that did not work.
Although as local administrator, I could open the form, I still could not open it as a Power User.
More information for you ...
We are using the Exchange Server for Outlook.
All our users (classified as Power Users) who are running Windows 2000 receive this error in Outlook 2000 when they try to open an Outlook Custom form.
"An error occurred registering the form in the OLE registry"
The form opens up fine for a user who is classified as Administrator...
I had same problem. The following steps resolved it.
Change the Permissions in the Registry (regedt32):
HKEY_LOCAL_MACHINE on Local Machine
Go to Software - Microsoft - Shared Tools
Open Graphics Filters
Click Security (on MenuBar)- Permissions
Select Users or Everyone and give them Full Control
Permissions to the Adaptec Software in the Registry must be changed to Full Control for all users to be able to write to the CD.
In the registry (regedt32)
HKEY_LOCAL_MACHINE
SOFTWARE
Select Adaptec
Security (on Menubar) - Permissions
Select Power Users and Check Full Control
Select Users or...
I have implemented the Full Screen view using the code:
'Application.DisplayFullScreen = True'
which hides all the toolbars, formula bar and status bar.
Is there anyway to also hide or diable the menubar.
I do not want the users to be able to use any of the commands on menu bar. I have set up my...
Thanks for your help! I opted for your first suggestion to hide the form. However I will keep the code you sent for keeping the form on top without focus for future reference.
HSMMIT
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.