Hi Janet,
The shortcut for Powerpoint through run is --> powerpnt
Thanks
Prashanth
On Thu, Jun 24, 2010 at 10:51 PM, janet dickson wrote:
> Hi Team
>
> *Sorry for asking this in excel group.*
>
> Does any one know the Shortcut for opening a MS Powerpoint using run box
> (Winkey + R) ??
>
> I ca
POWERPNT
On Thu, Jun 24, 2010 at 10:21 AM, janet dickson wrote:
> Hi Team
>
> *Sorry for asking this in excel group.*
>
> Does any one know the Shortcut for opening a MS Powerpoint using run box
> (Winkey + R) ??
>
> I can open several programs in run box (winkey + R) as shown below*:*
>
> MS Exc
Powerpnt
Regards,
Rohit Garg-Original Message-
From: janet dickson
Sent: 24/06/2010, 9:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help: powerpoint shortcut
Hi Team
*Sorry for asking this in excel group.*
Does any one know the Shortcut for opening a MS Powerpoint
Hi Team
*Sorry for asking this in excel group.*
Does any one know the Shortcut for opening a MS Powerpoint using run box
(Winkey + R) ??
I can open several programs in run box (winkey + R) as shown below*:*
MS Excel is *excel*
MS Word is *winword*
MS Access is *msaccess*
MS Outlook is *outlo
Have recorded a macro to protect and or hide certain sheets. The
macro has been assigned to a control button from the toolbox.
Looking for a prompt for a password before this macro can be run,
after clicking on the button. Any way to have the password show up in
the box as "*", rather than th
I'm a newbie but I found Excel 2007 VBA Programming for Dummies to be
easy to follow. You might want to search for some free, online
tutorials and videos (YouTube.com and others).
Good luck!
On Jun 24, 2:29 am, taruna kwatra wrote:
> Please someone help...
>
> I really want to learn VBA as it i
Thank you for the quick reply!
All in one column would be most beneficial, because some of these filenames
are very long. An example: Nevada Individual Self-Insurance Renewal
Application for Excess Workers' Compensation Coverage.xls
The number of files can change as new ones are added and old o
Hi Dave,
your code works very well. it seems to work for text in col B which
gives the same text in col C. I decided to make 2 columns for every
month of the year. so i just added more similar lines "if target =4
etc", if target =6 etc in your code. we still have all the accounts on
paper for every
are the file names fixed? or are they different from one day to the next?
what about the number of files? always 25?
how do you want them presented?
5 rows of 5 columns?
I have a couple of userforms that might work for you.
Paul
From: Leigh
To: MS EXCEL AND
What you do is select all cells in the sheet
(use the header cell in the top left)
Right-click and select "Format Cells"
On the Protection tab, make sure "locked" is selected
hit OK.
Now go through and select the cells you want available
for editing,right-click>Format Cells.
and REMOVE the checkbo
Is there other data in that column that you're NOT using?
If there's not, you can simply define the range extremely large.
Or... are you trying to find the last row with ANY data?
that is to say:
FBTlastrow = ActiveCell.SpecialCells(xlLastCell).Row
will give you the row number of the last row of
I am trying to accomplish this in Excel using VBA, and keep hitting
brick walls:
I would like to create a user form in Excel with checkboxes for 25
different files that exist in a source directory. I would like the
user to be able to check off the files that they want to copy, and
then move those
Dear All,
I want to prepare an excel calculator , in which some cells will have
definite values which the customer can't change once they download it from
our website, some cells should have the editable option where the customer
can enter values according to his requirements.
So can someone expl
Can not use like that.
All I know is which column i need to use. I do not know how long is the sum
range and where to start.
That's why I have FBTFirstrow and FBTlastrow . I need to have sum formular
in the cell so i can verify the formula
On Thu, Jun 24, 2010 at 3:22 PM, saggi wrote:
> If you
Hi Anton,Attached is a sheet with very simple code. Enter a value into a cell
in Column B, and you will see the adjacent cell in Col C increase by that
amount. Since this is done by VBA, there is no formula in the Col C cells, so
you can make manual corrections there if you want. You should not
You're welcome.Dave
> Date: Thu, 24 Jun 2010 12:47:24 +0200
> Subject: Re: $$Excel-Macros$$ Help
> From: regina.medha...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thanks!!!
>
> On Wed, Jun 23, 2010 at 10:20 PM, Dave Bonallack
> wrote:
> > Hi Regina,
> > The problem seems to be that XL
Thanks!!!
On Wed, Jun 23, 2010 at 10:20 PM, Dave Bonallack
wrote:
> Hi Regina,
> The problem seems to be that XL has dropped off the leading zeros, so
> sometimes your data is 6 characters long, and sometimes just 5.
> When the data is 6 characters long, you need MID(E2,1,4)
> But when the data i
Dear Jagjeet,
Thanks for your reply. It appears from your comment that two cells are
needed and Dave's suggestion will achieve this.
Best Regards,
anton
On Jun 24, 12:48 am, Jagjeet Singh wrote:
> Dear Anton
>
> Please send the sample sheet. as you have to input the values in two
> different cel
Hi Dave,
Thanks very much for your reply. Yes this would be sufficient. Your
suggestion that XL can monitor changes to A2 and store the cumulative
total in A3 would be great. I would have about 50 similar accounts
such as gas, books, donations, repairs etc.
Would you be able to construct this macro
Please someone help...
I really want to learn VBA as it is required in my job.
Thanks,
Taruna
On Jun 18, 10:30 am, taruna kwatra wrote:
> I am a beginner of VBA in Excel. Can anybody tell me good VBA book
> which will help me to learn it from scratch?
> Book should be simple to study.
>
> Thank
20 matches
Mail list logo
