Search results for query: *

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 need to prevent users from using Excel's Menu Bar, so they will be forced to use the form I created to close and save the workbook.

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

Actually I want to keep the form displayed at all times.

Is there any way to use a spreadsheet while a form created in VBA is displayed?