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!

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

Recent content by Romary

  1. Romary

    Disable Ability To Run Macros

    TonyJollans, After running this I don't have the Macros on the toolbar: Application.CommandBars("Tools").FindControl(ID:=30017).Delete How do I unDelete it?
  2. Romary

    Disable Ability To Run Macros

    TonyJollans & Loomah, Thank you for the valuable advice. Both options worked.
  3. Romary

    Disable Ability To Run Macros

    I have macros that lock down and unlock the contents of my spreadsheet. I don't want my users to be able to run these macros. How would I remove the ability to run macros from the spreadsheet? Ideally, I would like to remove the macro option from the toolbar.
  4. Romary

    Macro for unprotecting a workbook and unhiding a sheet

    Thank you for the suggestion but this unprotects a sheet. I need to unprotect the workbook. Tools-Protection-Unprotect Workbook.
  5. Romary

    Macro for unprotecting a workbook and unhiding a sheet

    The macro recorder doesn't record the unprotection of the workbook.
  6. Romary

    Macro for unprotecting a workbook and unhiding a sheet

    I need a macro that will unprotect my workbook and then unhide a sheet so that I can manipuate some cells on the hidden sheet. I then need to rehide the sheet and protect the workbook. How can this be done?
  7. Romary

    SAS - Table Row Number

    I have a table and I want a field to be the row number. How would I do this?
  8. Romary

    Lock Out Viewing Row and Column Headings

    Is there is a way to not allow a user to see the Row and Column Headings (Tools Options View) and to not allow a user to check the box to see the Row and Column Headings. In other words - create a spreadsheet where the user can never see the row and column headings.
  9. Romary

    Creating Subtotals & Grand Total in Answer set

    Shouldn't you exclude external claims in this query?
See more

Part and Inventory Search

Back
Top