Here is my problem

[grierfield]

Here is my problem

I have several command buttons programmed to select different criteria as per the below examples.

The spreadsheet is stored on a file server – the click_events works fine from my PC, but when I go to someones else PC the commands don’t work – I get the error message “Macro security setting is too high” even though I have no “macros” per say. The click events were all done in the visual basic editor – what is a fellow to do? HELP!

A click event example

Private Sub CommandButton2_Click()
With ActiveSheet
If Not .AutoFilterMode Then .[H2].AutoFilter

Range("H2").Select
Selection.AutoFilter
Selection.AutoFilter Field:=8, Criteria1:="MDR Kleb"

 

[AnotherHiggins]

VBA = macro

Lower their VB Security settings. Don't set it to low, that could be dangerous. But select a setting where it will ask the user if they want to enable macros. Then tell them to say 'yes'.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[bubba100]

Your code is a Macro. Look into the permissions that are set on your server, they may be locked down.

 

[HarleyQuinn]

Just as an aside, remind them to only say Yes to specific workbooks as quite often if they press Yes for one, they'll press Yes for them all and then the object of having macro security is defeated.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com

 

[AnotherHiggins]

Good point, Harley.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[grierfield]

Lower their VB Security settings. Don't set it to low, that could be dangerous. But select a setting where it will ask the user if they want to enable macros. Then tell them to say 'yes'.


i did do the above but only on one PC did it work - all the others the question "do you want to disable macro" just keep popping up after answering yes - i guess i may have to re-write the click events at each PC and see if that works.

 

[AnotherHiggins]

I should edit my earlier instruction. Don't always say 'yes', always enable the macros. If it is worded "do you want to disable macro," you would answer 'no' in order to enable them.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[grierfield]

I should edit my earlier instruction. Don't always say 'yes', always enable the macros. If it is worded "do you want to disable macro," you would answer 'no' in order to enable them.


thanks - i will try that and see what happens - that could be the trick