Is it possible to make a cell mandatory- without a macro and not allow
the workbook to be saved or emailed as attachment.
Thanks for any help
Shanu

I have two forms, let says they are called:
* frmEmployee
* frmLocation
On both of these forms I have two Combo Boxes, one called cboLocation and

Using Windows 2003 and Office XP;
I have the following in ThisWorkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True

I have design a excel with special field. I want program a button for
sending message via outlook , the message data with included excel file
special field data. Any soltuon for advice how can fix this problem.
IT

I use a shape for a button and assign a macro to this button.  When the user
presses the button, it kicks off the macro.
Is it possible to disable this shape if a certain condition is met?  If so,
how?  Any help would be appreciated.

Say i wanted to have a numbersonly function
I would Declare this in a new module, but when i call it
Function MyFunction(NewText as string)
On Error GoTo ErrorHandler

When I export a report from Access, the Excel files has two (extra) columns
(in line with the Column identifiers A, B, C, etc.), marked with a "1" and
"2", on the far left of the worksheet.  Clicking on the "1" collapses the
data so I can't see it anymore, and clicking on the "2" ...

I was using these lines of codes in EXCEL 2003 to get files names and dates
in a folder, they do not woork in EXCEL 2007. Any new codes or modification I
can use
Set obFileSearch = Application.FileSearch

In the sheet i have autofilter And after appled autofilter I need get of all
number rows in .AutoFilter.Range.SpecialCells(xlCellTypeVisible)
Thank you for you time

I am trying to add 1 to cells that have a neighbouring cell with the value
"Open" using VBA. This is what I have and it has melted my brain, I have a
feeling that its something blindingly obvious but for the life of me I cannot
figure it out. Please help.

Hi, Im running a macro which updates then time in Range("a1"),
(Range("a1").Value = Time). The macro goes of does its job, updating
the time at set intervals, then when conditions are met, in
Range("a2") it adds the time now + 60 minutes. In vba I want to say if

I want to do an FFT on some data.
I have recorded commands in a macro.
   Application.Run "ATPVBAEN.XLA!Fourier",
ActiveSheet.Range("$B$2:$B$4097"), _

I'm not sure whether my query is similar to others, but I hope
someone
can point me in the right direction.
I have an excel file with two worksheets. On both are a list of

Hi! I have quite a big code that calls other programs and reads and posts
data. I have not written all of the code, which is a problem. At the moment I
get Error 13 at a place. Can someone give me clue of what Error 13 might mean
in this context? Any help appreciated! Thanks

i'm working with excel 2000 and i have the next code in my program:
Private Sub cmb1_Click()
 myRow = ActiveCell.Row
 Dim Bcell As Range