It seems you need a new template standards.
Open a new workbook
Set the desired number of sheet in the workbook
Select all sheets at once as a group
Select all cells (Ctrl + A)
Format the cells of this workbook in your
own font-style, font-size, and so on,
including the format number (=
Hello,
Could you please let me know which software did you used with the link.
Thanks in advance.
Regards,
Chandra Shekar B
On Mon, Oct 31, 2011 at 1:10 PM, Brian brianfosterbl...@gmail.com wrote:
Thanks,
Problem solved
On Oct 22, 3:57 am, abhishek pandey gjobabhis...@googlemail.com
Dear Friends,
Request you to help me on a Query of Open Office Excel.
The Query is as fallows.
1. Can we protect the sheet as we do protect worksheet in XL.
2. Request you to help me in creating a macro to consolidate 40
files(Open Office Excel) in a XL sheet(2007).
3. All Heading
Dear Friends,
Request you to help me on a Query of Open Office Excel.
The Query is as fallows.
1. Can we protect the sheet as we do protect worksheet in XL.
2. Request you to help me in creating a macro to consolidate 40
files(Open Office Excel) in a XL sheet(2007).
3. All Heading
Dear Any one,
How can I want print all notepad files in landscape left 0.5 right 0.5
margin in one time
Thanks with
On Wed, Nov 16, 2011 at 6:49 PM, dguillett1 dguille...@gmail.com wrote:
http://forums.techguy.org/**business-applications/485943-**
Why not set up two printers using the same printer and modify this to suit
Sub PrintToAnotherPrinter()
Dim STDprinter As String
STDprinter = Application.ActivePrinter
Application.ActivePrinter = microsoft fax on fax:
' change printer
ActiveSheet.PrintOut
' prints the active sheet
Thank you.Will do that.
On Thu, Nov 17, 2011 at 12:36 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Skanda,
=trunc(-3.89811069564618E-07,16)
** **
But with General number format, Excel will still display with scientific
notation.
Change the number format to overcome
Sub test()
Dim rngap As Range
For Each rngap In Sheets(1).Range(m5:q17)
rngap = False
Next
End Sub
On Thu, Nov 17, 2011 at 8:11 PM, John A. Smith johnasmit...@gmail.comwrote:
Your help is appreciated. I need a macro to uncheck all the check boxes
on the attached spreadsheet. User will
Perfect! Thank you Ashish. Thank you very much.
John
On Thu, Nov 17, 2011 at 9:45 AM, ashish koul koul.ash...@gmail.com wrote:
Sub test()
Dim rngap As Range
For Each rngap In Sheets(1).Range(m5:q17)
rngap = False
Next
End Sub
On Thu, Nov 17, 2011 at 8:11 PM, John A. Smith
Another way would be to use a single line without a for loop
Sheets(1).Range(M5:Q17).Value = False
Regards,
Sam Mathai Chacko
On Thu, Nov 17, 2011 at 8:22 PM, John A. Smith johnasmit...@gmail.comwrote:
Perfect! Thank you Ashish. Thank you very much.
John
On Thu, Nov 17, 2011 at 9:45 AM,
The classic paste special window pops-up when a range is copied within the
current application, and the other paste special window pops-up when
something is copied in to the clipboard from outside the application, or a
non-range is copied from within application.
Regards,
Sam
On Thu, Nov 17,
Thank you Sam, that is a clean approach. Appreciate the help.
John
On Thu, Nov 17, 2011 at 11:19 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Another way would be to use a single line without a for loop
Sheets(1).Range(M5:Q17).Value = False
Regards,
Sam Mathai Chacko
On Thu, Nov 17,
Thanks Sam and Paul for the responses.
I actually found code on a site that will do exactly what i am looking
for. It verifies username and forces macros as well. The code works
great when I test it out on my computer...(using Excel 2010/WIN7).
When I set up for an employees computer (he is
Hi All,
Yes, I think for 2010, it is Micorosft Outlook 14.0 Object Library.
and it is already added in references but still it is giving the error.
Thanks
Kavita
On Thu, Nov 17, 2011 at 10:54 AM, Asa Rossoff a...@lovetour.info wrote:
Hi all,
Wouldn't it be Micorosft Outlook 14.0
Hi,
Plz tell me what is the use of indirect function what it can do?
Regards,
Ankit
On Tue, Nov 15, 2011 at 2:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Smitha,
Please find see attached sheet with example of below formula.
--
Thanks regards,
Noorain Ansari
15 matches
Mail list logo