Merged cells, both in the vba coding and on the sheet for formatting seem to be stopping the sharing of a workbook.

When I read this Note: does it say that merged cells are NOT supported so you must be sure to add them BEFORE sharing and then they will work okay?

Or are merged cells just plain not allowed in a shared workbook?

I know very little about sharing workbooks and have never done so myself. I sent a workbook to a OP and that person wants to use it as a shared workbook and it is not working because of merged cells.

Thanks,
Howard

*************
Note: Not all features are fully supported in a shared workbook. If you want to include any of the following features, you should add them before you save the workbook as a shared workbook. You cannot make changes to these features after you share the workbook.

Features that are not supported in a shared workbook
IN A SHARED WORKBOOK, YOU CANNOT: HOWEVER, THIS FUNCTIONALITY IS AVAILABLE:
Create an Excel table
Insert or delete blocks of cells You can insert entire rows and columns
Delete worksheets
Merge cells or split merged cells
*************

Hi Howard,

Am Mon, 10 Feb 2014 10:49:34 -0800 (PST) schrieb L. Howard:

Merged cells, both in the vba coding and on the sheet for formatting seem to be stopping the sharing of a workbook.

if merged cells don't work and centeracrossselection is not reliable
enough read the width and the height of the selection and place
textboxes or labels with the names and the color over the selection.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Monday, February 10, 2014 2:32:14 PM UTC-8, Claus Busch wrote:
Hi Howard,



Am Mon, 10 Feb 2014 10:49:34 -0800 (PST) schrieb L. Howard:



Merged cells, both in the vba coding and on the sheet for formatting seem to be stopping the sharing of a workbook.



if merged cells don't work and centeracrossselection is not reliable

enough read the width and the height of the selection and place

textboxes or labels with the names and the color over the selection.





Regards

Claus B.

--

So the bottom line is no merged cells with a shared workbook, either before or after saving as a shared workbook.

Would you still be able to add comments to the selection or would the textbox/label prevent that?

I'll study up some on how to incorporate textbox/labels via code.

Thanks.
Howard

Hi Howard,

Am Mon, 10 Feb 2014 16:56:40 -0800 (PST) schrieb L. Howard:

Would you still be able to add comments to the selection or would the textbox/label prevent that?

if you insert a textbox or a label you can't select the cell behind. So
it is impossible to add a comment. you can place the comment in a cell
in front or behind the selection.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Monday, February 10, 2014 11:17:22 PM UTC-8, Claus Busch wrote:
Hi Howard,



Am Mon, 10 Feb 2014 16:56:40 -0800 (PST) schrieb L. Howard:



Would you still be able to add comments to the selection or would the textbox/label prevent that?



if you insert a textbox or a label you can't select the cell behind. So

it is impossible to add a comment. you can place the comment in a cell

in front or behind the selection.





Regards

Claus B.

--

After playing around with text boxes, I was coming to that conclusion.

I found this code that does an excellent job of filling a selection neatly with a text box.

I have a couple of other codes that add a predetermined text to the text box (Which would be a name in this case) and color but I cannot incorporate those methods into this preferred code.

One code also names the text box and therefore gets away from the ever increasing TextBox10, 11, 12, 13 etc.

So neat as this little snippet is, I lack the ability to add the centered text "Charlie", a chosen background color, and name it TB_Charlie.

I am pretty sure I can get the delete text box code from the macro recorder by going into Design Mode, click on the text box and delete it while recording.

I'm not sure why this Dim statement was included in the code.

Dim oTB As Object

Works okay commented out...?

Thanks.
Howard


Sub TextBoxSelection()
Dim ws As Worksheet

Dim oTB As Object
Set ws = Worksheets("Sheet2")
If TypeName(Selection) = "Range" Then
With Selection
ActiveSheet.Shapes.AddTextBox _
msoTextOrientationHorizontal, .Left, _
.Top, .Width, .Height
End With
End If
End Sub

Hi Howard,

Am Mon, 10 Feb 2014 23:52:36 -0800 (PST) schrieb L. Howard:


ActiveSheet.Shapes.AddTextBox _
msoTextOrientationHorizontal, .Left, _
.Top, .Width, .Height

I guess the OP would write:
set oTB= ActiveSheet.Shapes.AddTextBox _
( msoTextOrientationHorizontal, .Left, _
.Top, .Width, .Height)

that he could refer to oTB to set other properties.

Pleas look again he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for "DeskBooking"

I copied a row of the table to BE10:BX10 with columnwidth.
Now you can select a range into the table and run "Test_CB". The same
range will be selected in BE10:BX10, will be colored and get the name
and then this range will be copied as picture back into the table.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2