disable unhide sheets on toolbar
is there a way to dis-able the unhide sheets toolbar?
Protect the workbook (Tools > Protection menu) to prevent hiding, unhiding
and renaming of sheets.
HTH. Best wishes Harald
"ditchy" <firstname.lastname@example.org> skrev i melding
> is there a way to dis-able the unhide sheets toolbar?
> TIA, Ditchy
If you want to take out that control then use
Bar").Controls("Format").Controls("Sheet").Co...spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.
If anyone knows how I can get this behavior to work, it would be GREATLY
I did a record new macro, and got code similar to the following:
Add the fiollowing to your code as shown:
...Amazing Problem in AllocPhysMem wince 6.0
I am writing a Port Driver for x86 platform in WinCE 6.0. I want to
allocate virtual and equivalent physical memory in driver and mapped
it to USER mode to use application. For that I used AllocPhysMem in
driver and passed that
address through IOCTL calls but i cant use that virtual and physical
address in application side. Because AllocPhysMem returns Error Code
as 0x57 (meaning Parameter incorrect).
But the same code is working in WinCe 5.0.
My code snippet is,
VirAddress = (LPVOID)AllocPhysMem(32,
...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...Help revising slow code
I am using the following code to remove all the lines in a worksheet that
have a zero value in Column H. Because there are thousands of rows in the
worksheet, this loop takes forever! Does anyone have any suggestions for
doing this more quickly? Thanks!
Dim Firstrow As Long
Dim LastRow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...Outlook
Is there a way of stopping OL from destroying HTML code when forwarding
HTML formatted emails ... it seems to be very, very aggressive and eats
any formatted mail that I attempt to send, it inserts <p> tags every
where - I've even seen it change the height and width attributes of
<img> tags etc. etc. This hasn't anything to do with my local
settings - I've tried every possible combination and permutation of
every check box and select box there is to be found - all to no avail
- we've been able to consistently reproduce this issue on both
sides of the world on many, ...Macro Copy and Paste
I am currently trying to copy from one workbook that has 7 differen
tabs and paste into one worksheet on a separate master workbook. M
problem is that when I set up the macro to copy from one of the tabs i
the workbook and paste to the other work book, I only want the the row
to come in where there is data. Currently I am having to run a macr
that takes every 100 lines, but ideally I only want the informatio
copy and pasted where there is only data.
In addition, once I have copy and pasted everything from the first tab
my next step is to copy and paste information from the second tab t
th...Referring to a FileName in Macro
I have a Macro with the following code
TestQry is the name of the file. Is there anyway that this macro cod
can refer to the activeWorkbook or filename so that if the file i
saved to a new name this macro will still ru
Message posted from http://www.ExcelForum.com
How about just:
"DoctorV <" wrote:
> I have a Macro with the following code
> Application.Run "TestQry!Macro2"
> Application.Run "TestQry!Macro1"
&g...Macro Question #10
I am working with a text file that I imported into Excel.
It is a transactional report of sales by customer. The
data will have the customer number and name spread out
over three cells. What I want to do is to create a macro
that will contatenate all three cell and then perform a
paste special and paste them into another cell in another
column. Since the number of transactions by customer can
vary the customer name and number can appear anywhere on
I created a macro to do this using the first customer
which appears in cell B5 through D5. The next customer
appears...Can you record a macro in Publisher like you can in Excel?
In Excel I use the feature to Record a Macro. Excel records the keystrokes
and converts to VB. Does Publisher have that option? In my version,
Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
don't know how to code VB.
> In Excel I use the feature to Record a Macro. Excel records the keystrokes
> and converts to VB. Does Publisher have that option? In my version,
> Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
> don't know how to code VB.
Publisher does not have a Macro Recorder, sorry.
--...Setting up Exchange 2003
I had this problem the other day while extending the schema in
preparation for an upgrade to Exchange 2003. I searched through a lot
of databases and search engines, and found that a lot of people have
had this problem, but none of the forums led to a clear cut answer to
the issue. So, I thought I'd share my solution to try and help others
out, and save them some time and frustration. I was ready to call
Microsoft support right before I figured this out.
While running forest prep (setup /forestprep), setup failed with Error
code 0XC103798A. It then specified to check the Exchange inst...Multi-Select Listbox VBA code causing overflow in loop
Private Sub Form_Current()
Dim oItem1 As Variant
Dim oItem2 As Variant
Dim bFound1 As Boolean
Dim bFound2 As Boolean
Dim sTemp1 As String
Dim sTemp2 As String
Dim sValue1 As String
Dim sValue2 As String
Dim sChar1 As String
Dim sChar2 As String
Dim iCount1 As Integer
Dim iCount2 As Integer
Dim iListItemsCount1 As Integer
Dim iListItemsCount2 As Integer
sTemp1 = Nz(Me!SignsList.Value, " ")
sTemp2 = Nz(Me!SymptomsList.Value, " ")
iListItemsCount1 = 0
iListItemsCount2 = 0
bFound1 = False
bFound2 ...Best C# Book for VBA Programmers
I have been developing in Excel/VBA/SQL for 10+ years and have a little
I have a pretty good - but certainly not great - understanding of OOD &
I want to get into C# as more and more Jobs that I'm interested in are
looking for +/or expecting it but I have zero knowledge of C of any
Given my background I would value all your thoughts on which is the
best book(s) to buy.
Or are there some ace WebSites / Parts of MSDN that I could use to
achieve the same end?
Thanks in advance
I would reccomend learning a non-microsoft language.
Microsoft has proven time...Generating Code...
Recently I have encountered what appears to be an endless hangup, tying up
100% of the cpu. Could someone explain what is going on here?
cl.exe terminated at user request.
Tool execution canceled by user.
I might add that this is still occurring after resetting my Release Project
Settings. The Debug configuration is fine.
"SteveR" <email@example.com> wrote in message
> Recently I have encountered what appears to be an endless hangup, tying up
> 100% of th...Spreadsheet macro stopped working!
I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:
Scorecard, statistics, database and equations (for calculating some
I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for ...Hidden Outlook Directory
Outlook appears to have a hidden directory where it
stores/places attachments which you have opened from
within an email. The path is C:\Documents and
Settings\Admin\Local Settings\Temporary Internet Files>.
The hidden directory, on my pc, is called OLK22A.
Problem with the directory is that I can only see it/get
to it via a dos window. It doesn't show up in Windows
Explorer even though I indicated that I wanted Explorer
to show all hidden files and directories.
How can I unhide this directory? I don't like having
things sit on my harddrive that I don't want and/o...Excel 2007 macro compatability
I have created a macro in Excel 2007 that includes importing a text file. It
works fine on my PC, but fails on a co-workers PC running Excel 2000. The
failure points to the "TextFile Platform" command in the macro. I have tried
several (437, 1252, 20127), but get the same results.
Have you try
Regards Ron de Bruin
"Al @ Frontier" <Al @ Frontier@discussions.microsoft.com> wrote in message
>I have cr...Help Locking Worksheet
I inherited a workbook that has several sheets, have gone thru and mad
changes and now when I lock it I cannot go from the last table cell o
the first row to the second row. Tabbing will just continue you out o
the same row. I want to be on cell BD3, hit tab and go to C5.
Does the fact that I have the to & leftmost cells frozen have anythin
to do with this? How can I fix it
jlabsher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelfo...Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try
to change to that paper size in print options, there is
no size like that available. What do I do??? thank you
for your help in this matter.
It's the printer that decides that.. Do you have that option on the printer
it should be available in Excel
"Katie" <firstname.lastname@example.org> wrote in message
> I want to print a worksheet on 11x17 paper. When I try
> to change to that paper size in print options, there is
...how do I prevent a worksheet from being copied in excel
yet allow users to select values in a defined range
Good evening kensanjose
You really need to supply more information about what you mean - cop
the file/sheets/ranges etc
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38531
How do I prevent a worksheet from being copied in excel? Can I disable right
click within a file so that the sheet cannot be copied into another file and
manipula...Excel E-mail Macros
I need to know how to create a macro that will send an
excel file as an attachment to one individual, and then
send one of the file's worksheets to 3 e-mail addresses
using the mail recipient method so that the worksheet
appears in the body of the e-mail. The e-mail program I
am using is Outlook.
Any help with this will be GREATLY appreciatd.
I'd tell you, but Ron de Bruin already did all the work. It'd be silly for
me to do it again...Try Ron's site:
"John" <email@example.com> wrote in message
ne...error code 0x800703EE
I received error code 0x800703EE when trying to install SP2 for vista-32bit
OS. any help with this error code would be appreciated.
System could not allocate the required space in a registry log;
The volume for a file has been externally altered so that the opened
file is no longer valid.
How to obtain the latest version of the Windows Update Agent [v7.4.7600.226]
to help manage updates on a computer:
I'm suяe someone else will help you if this suggestion doesn't help.
...Blocking Old SKU or PLU code?
I have ran into a problem in blocking Old SKU's or PLU's code in our database
that the Director of Retail has express interest in having them removed from
the system. I the worksheet 250 - Update Inventory Items, which work fine
on all stores we open in the last 2 years, but all other stores has "An Error
occured while attempting to process the worksheet." I know from the list if
items to be blocked that some have been blocked by management in the past and
later turn back on using SQL database to make the item show up in RMS again.
I am thinking this is where my pr...format macro
Last week, Art was trying to help me with this, but the solution doesn't work
for me. I'm looking for a macro that would be contained within my
personal.xls, that I could use as needed.
Lets say I have A1:C5 selected, which represent headdings and data for jan,
feb and march. [On a different spreadsheet, it may be different columns, or
a different number of columns. The point is that I will select the range
before I run the macro.]
I want to do an auto fit for each column, so that the column widths are big
enough to fit the numbers. No problem, format-->column-->autof...