Excel question

When replying to me TOP post
Did NOT get your file. Did you send to my address below

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Swinder" <(E-Mail Removed)> wrote in message
news:ea94435f-d418-42f2-80c5-(E-Mail Removed)...
On Feb 8, 1:35�pm, "Don Guillett" <(E-Mail Removed)> wrote:
> � � � If desired, send your file to my address below. I will only look if:
> � � � 1. You send a copy of this message on an inserted sheet
> � � � 2. You give me the newsgroup and the subject line
> � � � 3. You send a clear explanation of what you want
> � � � 4. You send before/after examples and expected results.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)"Swinder" <(E-Mail Removed)> wrote in message
>
> news:74ab6318-f1a6-461f-8551-(E-Mail Removed)...
> On Feb 8, 8:18 am, "Don Guillett" <dguille...@gmail.com> wrote:
>
>
>
>
>
> > Get a button or shape or any shape from anywhere and right click on it
> > to
> > assign to the macro.
>
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > dguill...@gmail.com"Swinder" <swinde...@gmail.com> wrote in message
>
> >news:8e582cd5-1d23-42d7-b006-(E-Mail Removed)...
> > On Feb 7, 6:12 pm, "Don Guillett" <dguille...@gmail.com> wrote:
>
> > > sub addnum()
> > > for each c in selection
> > > c.value = c.value+7
> > > next c
> > > end sub
>
> > > game time
>
> > > --
> > > Don Guillett
> > > Microsoft MVP Excel
> > > SalesAid Software
> > > dguill...@gmail.com"Swinder" <swinde...@gmail.com> wrote in message
>
> > >news:cfc61aa7-189a-428f-87b4-(E-Mail Removed)...
>
> > > >I have a very basic spreadsheet with data in it. What I want to be
> > > > able to do is add a button that a user can click which will execute
> > > > a
> > > > basic command of simply adding a fixed amount (like +7) to a
> > > > specific
> > > > set of the data and another amount to another column of data. I
> > > > imagine this is pretty simple to do, but I can not quite figure it
> > > > out.
>
> > > > ~Thanks.
>
> > Thanks for the fast reply. I understand how to put that in VB and I
> > see where I can select cells and then run it and have it make the
> > change. Is there a way though I can make like a button or something on
> > the worksheet itself that I can simply click on to have it run this
> > without having to select the cells and then go into the VB editor
> > every time? That part I can't seem to get.
>
> Ok so I was able to create a button and I see how to edit the macro in
> it to have it do what I want. Unfortunately now when I try to actually
> click on it to run it it tells me: "Can not run the macro. The macro
> may not be available in this workbook or all macros may be disabled."
> I have it set to enable all macros.

I appreciate the offer, I just sent you an e-mail.