Hi,
I have preset filters recorded for different status, so at a click of a
button anybody can view pending cases which are at a very high status.
But the buttons do not function when I protect the sheet, even though I

Hi all, first post so please be gentle!  :)
I'm currently putting together a VBA Macro to allow less Excel minded
people to use a complex pivot table.  I am able to get the macro to run
as I want it to, except I cannot find the right way to allow the user to

I am filtering my data, based on user input.  But I need a way to reset
the filters, here is some example code.  Say I filter by one, then
reset the data by using Spreadsheet1.ActiveSheet.ShowAllData  then they
try to filter by "2".  Problem is that it includes "1" and "2".  How

I have no problems assigning a macro to a custom button on a toolbar.  
Everything works fine when I open the file on my PC.
Problem:  When I sent the file to a colleague the buttons are no longer
available.  The macro is still functional from the keyboard shortcut or

There is a beautiful code
Private Sub ComboBox1_Change()
    Dim TargetPivotTable As PivotTable
    On Error GoTo ErrHandler

Once more into the breech dear friends...
Contrary to what I thought, my problem with the variable for sending
the email has not been resolved. However, I have narrowed down what is
going on, I just don't know how to fix it.

I have written a few user-defined functions all stored in the same
module but some of them do not give the argument list when I use them
within an excel sheet.
I have tried copying the code to different modules, copying the bulk of

Just discovered that you can't rely on the old Dir function to check if a
file exists or not and I thought it might be worth it to post this to this
forum.
I always used a function like this to test if a file exists:

I have a spreadsheet that I only want to use for user input.  The user will
fill out a UserForm and then when the click a button, I want the information
they entered to be put into a worksheet (Columns A through I) in the next
empty row.

I have code that shows a specific commanbar when a particular worksheet
is activated, then hides the commandbar when the spreadsheet  is
de-selected. I want to save the commandbar name so that when the
spreadsheet is closed, the last commandbar will be hidden. But I'm

Iam trying to copy a sheet using VBA, but in vain,
The code is very simple as below,
Sheets("Sheet1).Copy After:=Sheets(Sheets.Count)
But the execution bombs out without any error notification.

Would like to see a distance number cell formatting category.  One that
allows any numerical to be expressed in terms of feet and inches -- or other
units of measurement.  It should also should allow for metric to English
conversions, or vis-versa.  An anlagous set of formats for ...

Excuse me for my poor english, but I am currently in some kind o
despreate situation here.
I am asked to create an invoicing utility of some sort by extractin
data from different spreadsheets in an excel file.

Hi all...
I have a macro to archive some daily sales.  What i want to do for th
procedure below is send the info to a closed workbook rather than th
active one.  The reason for this is just to keep the active workboo

As I am only a hack when it comes to programming I need a little hel
with something that I’m sure is really easy.
I kinda have a program that records data for a day and then at the en
of the day adds it to the end of another spreadsheet that keep all th