I want a user to be able to paste text into a cell but not change the
format (e.g., text alignment) of the cell. The cells are on a protected
sheet, but these are unlocked. The content that will be pasted may be
copied from any source (e.g., a text editing program).
Is this possible?
Tha
Is there a way to disable the user editing the contents and size of a shape
but allowing them to drag and drop the shape?
I have shapes containing formulas. I would like the user to be able to
change the position of a shape but not edit its content (the formulas) or
size. Is there a way to do
Thanks! This worked. However, I am not exactly sure why I got the weird
results without that.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1)
I have changed the format of the columns and re-edited all the cells. This
got rid of the invalid results, but I still get many incorrect results on
the letters. I have looked up this topic on Google, but I have been able
to resolve this frustrating problem!
See attached, revised spreadsheet.
I am really confused about the behavior of my VLOOKUP functions in Column 2
of the attached spreadsheet. The function is simply
=VLOOKUP(A1,$E$1:$F$17,2). This is giving me wrong (undefined, or wrong
number) results for some of what I`m looking up. I have not found the
cause or a way around
This worked:
ActiveWorkbook.Worksheets("MyList").Range("B2:C37").Sort _
Key1:=Worksheets("MyList").Range("B2:B37")
I had to put the .Range in the statement before the Sort method.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Thank you for the attempt, but this did not work. If I use your code
example, I get the same runtime error on this line:
With ActiveWorkbook.Worksheets("MyList").Sort
I don`t understand why this does not work!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
I have a VBA macro created in Excel 2010, where it works fine. However, I
get the following error when I run it in Excel 2003 (file saved in 2003
format):
Runtime error '438':
Object doesn't support this property or method
Range("B2:C37").Select
Range("C2").Activate
ActiveWindow.S
