Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HSMMIT
  • Content: Threads
  • Order by date
  1. HSMMIT

    Reduce Size of Excel Macros

    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...
  2. HSMMIT

    Outlook Custom Form cannot be registered in OLE registry

    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...
  3. HSMMIT

    Disable or Hide Excel Menu Bar

    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.
  4. HSMMIT

    Disable or Hide Excel MenuBar

    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...
  5. HSMMIT

    Activate a spreadsheet while a form is displayed in Excel

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

Part and Inventory Search

Back
Top