Single Use Comand Button

**JamesT1** · 09-20-2008, 02:04 AM

Hi

Is it possible to have a button you can only use once.

e.g. a button to sort a list of people into alphabetial order, once used any new staff added at the bottom would not be sorted

Thanks

**broro183** · 09-20-2008, 04:08 AM

Hi James,

Yes, it's possible. The next question could be how bulletproof do you want it to be (ie do you want to stop people from manually completing a Sort as well*)?
* someone else would need to help you with this.

Here is one approach for a single push button

Please Login or Register  to view this content.

hth
Rob

**Leith Ross** · 09-20-2008, 05:29 AM

Hello broro183,

Adding on to Rob's code, this macro will enable/disable the Sort... menu item. It will be re-enabled when you close the workbook.

Macro to Enable/Disable the Sort Menu Selection

Please Login or Register  to view this content.

Rob's code with call to New Macro

Please Login or Register  to view this content.

Add this macro to ThisWorkbook Module

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**JamesT1** · 09-20-2008, 12:07 PM

Thankyou both for your help,, now workd fine,,, much appreciated

**broro183** · 09-21-2008, 02:28 AM

Very nice Leith :-)

Thanks for the feedback

Single Use Comand Button

LinkBack

Thread Tools

Rate This Thread

Display

Single Use Comand Button

Thread Information

Users Browsing this Thread

Similar Threads

Building a "sheet" inside a single cell

Forms: system error + error 361

Plotting straight line using a single value

Append multiple worksheets into single worksheet

New to writing macros

Bookmarks

Bookmarks

Posting Permissions